<##CommentDropBegin##>
if exists(select * from sysobjects where type='p' and name='<##SelectProcedureName##>')
	drop proc <##SelectProcedureName##>
go
<##CommentDropEnd##>

create proc <##SelectProcedureName##>
	@id int
as
	select * from <##TableName##> where id=@id
	
go

<##CommentDropBegin##>
if exists(select * from sysobjects where type='p' and name='<##InsertProcedureName##>')
	drop proc <##InsertProcedureName##>
	
go
<##CommentDropEnd##>

create proc <##InsertProcedureName##>
<##InsertParameters##>
as
	insert into <##TableName##>(<##InsertFields##>)
	vlaues(<##InsertValues##>)
	
go

<##CommentDropBegin##>
if exists(select * from sysobjects where type='p' and name='<##UpdateProcedureName##>')
	drop proc <##UpdateProcedureName##>
	
go
<##CommentDropEnd##>

create proc <##UpdateProcedureName##>
	@id int,
<##UpdateParameters##>
as
	update <##TableName##> set 
<##UpdateSetFields##>
	where id=@id
	
go

<##CommentDropBegin##>
if exists(select * from sysobjects where type='p' and name='<##DeleteProcedureName##>')
	drop proc <##DeleteProcedureName##>
	
go
<##CommentDropEnd##>

create proc <##DeleteProcedureName##>
	@id int
as
	delete from <##TableName##>  
	where id=@id
	
go
		